/*
 * ContatoDAO.java
 *
 * Created on 18 de Novembro de 2006, 11:57
 *
 * To change this template, choose Tools | Template Manager
 * and open the template in the editor.
 */

package persistence;
import model.Contato;
import java.sql.*;

public class ContatoDAO {
  private static ContatoDAO instance= new ContatoDAO();
  private ContatoDAO() {}
  public static ContatoDAO getInstance() {
    return instance;
  }
  
  public void save(Contato contato) throws SQLException, ClassNotFoundException {
    Connection conn = null;
    Statement st  = null;

    try {
      conn = DatabaseLocator.getInstance().getConnection();
      st = conn.createStatement();
      st.execute("insert into contato (nome, email)" +
        " values ('" + contato.getNome() + "', '" + contato.getEmail() + "')");
    } catch(SQLException e) {
      throw e;
    } finally {
      closeResources(conn, st);
    }
  }
  public void closeResources(Connection conn, Statement st) {
    try {
      if(st!=null) st.close();
      if(conn!=null) conn.close();
      
    } catch(SQLException e) {
      
    }
  }
  
  
}
